SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO




CREATE PROCEDURE [dbo].[usp_AddEmployer]
    (
      @JOL_Employer_Account VARCHAR(50) ,
      @JOL_Employer_Password VARCHAR(50) ,
      @JOL_Employer_Name VARCHAR(50) ,
      @JOL_Employer_Industry VARCHAR(50) ,
      @JOL_Employer_Type VARCHAR(50) ,
      @JOL_Employer_Province VARCHAR(50) ,
      @JOL_Employer_City VARCHAR(50) ,
      @JOL_Employer_Address VARCHAR(50) ,
      @JOL_Employer_ZipCode VARCHAR(50) ,
      @JOL_Employer_HomePage VARCHAR(255) ,
      @JOL_Employer_Introduction NTEXT ,
      @JOL_Employer_Linkman VARCHAR(50) ,
      @JOL_Employer_Mobile VARCHAR(50) ,
      @JOL_Employer_Email VARCHAR(50) ,
      @JOL_Employer_Phone VARCHAR(50) ,
      @JOL_Employer_Fax VARCHAR(50) ,
      @JOL_Employer_VerifyStatus VARCHAR(50) ,
      @JOL_Employer_Credentials VARCHAR(50) ,
      @JOL_Employer_IsSchoolCorperate BIT ,
      @JOL_Employer_IsContactVisible BIT ,
      @JOL_Employer_IsVIP BIT ,
      @JOL_Employer_CredentialsFileLink VARCHAR(255) ,
      @JOL_Employer_AddUser VARCHAR(50) ,
      @JOL_Employer_VerifyUser VARCHAR(50)
    )
AS 
    INSERT  INTO dbo.JOL_Employer
            ( JOL_Employer_Account ,
              JOL_Employer_Password ,
              JOL_Employer_Name ,
              JOL_Employer_Industry ,
              JOL_Employer_Type ,
              JOL_Employer_Province ,
              JOL_Employer_City ,
              JOL_Employer_Address ,
              JOL_Employer_ZipCode ,
              JOL_Employer_HomePage ,
              JOL_Employer_Introduction ,
              JOL_Employer_Linkman ,
              JOL_Employer_Mobile ,
              JOL_Employer_Email ,
              JOL_Employer_Phone ,
              JOL_Employer_Fax ,
              JOL_Employer_AddTime ,
              JOL_Employer_UpdateTime ,
              JOL_Employer_VerifyStatus ,
              JOL_Employer_Credentials ,
              JOL_Employer_IsSchoolCorperate ,
              JOL_Employer_IsContactVisible ,
              JOL_Employer_IsVIP ,
              JOL_Employer_CredentialsFileLink ,
              JOL_Employer_AddUser ,
              JOL_Employer_UpdateUser ,
              JOL_Employer_VerifyUser ,
              JOL_Employer_VerifyTime
            )
    VALUES  ( @JOL_Employer_Account , -- JOL_Employer_Account - varchar(50)
              @JOL_Employer_Password , -- JOL_Employer_Password - varchar(50)
              @JOL_Employer_Name , -- JOL_Employer_Name - varchar(50)
              @JOL_Employer_Industry , -- JOL_Employer_Industry - varchar(50)
              @JOL_Employer_Type , -- JOL_Employer_Type - varchar(50)
              @JOL_Employer_Province , -- JOL_Employer_Province - varchar(50)
              @JOL_Employer_City , -- JOL_Employer_City - varchar(50)
              @JOL_Employer_Address , -- JOL_Employer_Address - varchar(50)
              @JOL_Employer_ZipCode , -- JOL_Employer_ZipCode - varchar(50)
              @JOL_Employer_HomePage , -- JOL_Employer_HomePage - varchar(255)
              @JOL_Employer_Introduction , -- JOL_Employer_Introduction - ntext
              @JOL_Employer_Linkman , -- JOL_Employer_Linkman - varchar(50)
              @JOL_Employer_Mobile , -- JOL_Employer_Mobile - varchar(50)
              @JOL_Employer_Email , -- JOL_Employer_Email - varchar(50)
              @JOL_Employer_Phone , -- JOL_Employer_Phone - varchar(50)
              @JOL_Employer_Fax , -- JOL_Employer_Fax - varchar(50)
              GETDATE() , -- JOL_Employer_AddTime - datetime
              NULL , -- JOL_Employer_UpdateTime - datetime
              @JOL_Employer_VerifyStatus , -- JOL_Employer_VerifyStatus - varchar(50)
              @JOL_Employer_Credentials , -- JOL_Employer_Credentials - varchar(50)
              @JOL_Employer_IsSchoolCorperate , -- JOL_Employer_IsSchoolCorperate - bit
              @JOL_Employer_IsContactVisible , -- JOL_Employer_IsContactVisible - bit
              @JOL_Employer_IsVIP , -- JOL_Employer_IsVIP - bit
              @JOL_Employer_CredentialsFileLink , -- JOL_Employer_CredentialsFileLink - varchar(255)
              @JOL_Employer_AddUser , -- JOL_Employer_AddUser - varchar(50)
              NULL , -- JOL_Employer_UpdateUser - varchar(50)
              @JOL_Employer_VerifyUser , -- JOL_Employer_VerifyUser - varchar(50)
              --NULL  -- JOL_Employer_VerifyTime - datetime
              CASE @JOL_Employer_VerifyStatus
                WHEN '已审核' THEN GETDATE()
                ELSE NULL
              END
            )



GO
